﻿<html DIR="LTR" xmlns:tool="http://www.microsoft.com/tooltip" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:ddue="http://ddue.schemas.microsoft.com/authoring/2003/5" xmlns:MSHelp="http://msdn.microsoft.com/mshelp">
  <head>
    <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=utf-8" />
    <META NAME="save" CONTENT="history" />
    <title>AdventureWorksOffline Report Samples</title>
    
    
    
    <style TYPE="text/css">
body
{
background: #FFFFFF;
color: #000000;
font-family:    Verdana;
font-size: medium;
font-style: normal;
font-weight: normal;
margin-top: 0;
margin-bottom:  0;
margin-left:    0;
margin-right:   0;
width:  100%;
}

div.#mainSection
{
font-size: 70%;
width: 100%;
padding-left:    10;
margin-right: 10;
}

div.#mainBody
{
font-size: 90%;
margin-top: 10;
padding-bottom: 20;
}

div.#header
{
background-color: #D2D2D2;
padding-top:    0;
padding-bottom: 0;
padding-left:   10;
padding-right:  0;
width:          100%;
}

div.#header table
{
border-bottom-color: #C8CDDE;
border-bottom-style: solid;
border-bottom-width: 1;
width:  100%;
}

span.#runningHeaderText
{
color: #003399;
font-size: 90%;
}

span.#nsrTitle
{
/*    color: #003399;*/
font-size: 120%;
font-weight: 600;
}

div.#header table td
{
color: #000000;
font-size: 70%;
margin-top: 0;
margin-bottom:  0;
padding-right: 20;
}

div.#header table tr.#headerTableRow3 td
{
padding-bottom: 2;
padding-top: 5;
}

div.#header table.#bottomTable
{
border-top-color: #FFFFFF;
border-top-style: solid;
border-top-width: 1;
text-align: left;
}

div.#footer
{
font-size: 90%;
margin-top: 0;
margin-bottom:  0;
margin-left:    -5;
margin-right:   0;
padding-top:    2;
padding-bottom: 2;
padding-left:   0;
padding-right:  0;
width:  100%;
}

hr.#footerHR
{
border-bottom-color: #EEEEFF;
border-bottom-style: solid;
border-bottom-width: 1;
border-top-color: C8CDDE;
border-top-style: solid;
border-top-width: 1;
height: 3;
color: #D2D2D2;
}

div.section
{
padding-top:    2;
padding-bottom: 2;
padding-right:  15;
width:  100%;
}

.heading
{
color:          #000000;
font-weight:    bold;
margin-top:     18;
margin-bottom:  8;
}

h1.heading
{
color: #000000;
font-size:  150%;
}

.subHeading
{
color:          #000000;
font-weight:    bold;
font-size:      150%;
margin-bottom:  4;
}

h2.subHeading
{
color:          #000000;
font-weight:    bold;
font-size:      130%;
}
h3.subHeading
{
color:  #000000;
font-size: 125%;
font-weight: bold;
}

h4.subHeading
{
color: #000000;
font-size: 110%;
font-weight: bold;
}

h4.procedureHeading
{
color: #000080;
font-size: 110%;
font-weight: bold;
}

h5.subHeading
{
color: #000000;
font-size: 100%;
font-weight: bold;
}

img
{
padding-bottom: 10;
}

img.toggle
{
border: 0;
margin-right: 5;
padding-bottom: 10;
}

img.copyCodeImage
{
border: 0;
margin: 1;
margin-right: 3;
padding-bottom: 10;
}

img.downloadCodeImage
{
border: 0;
margin-right: 3;
padding-bottom: 10;
}

img.viewCodeImage
{
border: 0;
margin-right: 3;
padding-bottom: 10;
}

img.note
{
border: 0;
margin-right: 3;
padding-bottom: 10;
}

img.#membersOptionsFilterImage
{
border: 0;
margin-left: 10;
vertical-align: middle;
padding-bottom: 10;
}

img.#toggleAllImage
{
margin-left: 4;
vertical-align: middle;
padding-bottom: 10;
}

div.#mainSection table
{
border: 0;
font-size: 100%;
width:  100%;
margin-top: 5px;
margin-bottom: 15px;
}

div.#mainSection table tr
{
vertical-align: top;
}

div.#mainSection table th
{
text-align: left;
background: #D8D8D8;
border-bottom-color: #D8D8D8;
border-bottom-style: solid;
border-bottom-width: 1;
color: #000000;
padding-left: 5;
padding-right: 5;
}

div.#mainSection table td
{
background: #F2F2F2;
border-top-color: #D8D8D8;
border-top-style: solid;
border-top-width: 1;
padding-left: 5;
padding-right: 5;
}

div.#mainSection table td.imageCell
{
white-space: nowrap;
}

div.code
{
width: 98%;
}

div.code table
{
border: 0;
font-size: 95%;
margin-bottom: 5;
width: 100%
}

div.code table th
{
text-align: left;
background: #D8D8D8;
border-bottom-color: #D8D8D8;
border-bottom-style: solid;
border-bottom-width: 1;
color: #000000;
font-weight: bold;
padding-left: 5;
padding-right: 5;
}

div.code table td
{
background: #CCCCCC;
border-top-color: #D8D8D8;
border-top-style: solid;
border-top-width: 1;
padding-left: 5;
padding-right: 5;
padding-top: 5;
}

div.alert
{
margin-left: 10;
width: 98%;
}

div.alert table
{
border: 1;
font-size: 100%;
width:  100%;
border: solid 1 #DEDFEF;
}

div.alert table th
{
text-align: left;
background: #D8D8D8;
border-bottom-width: 0;
color: #000000;
padding-left: 5;
padding-right: 5;
border: solid 1 #DEDFEF;
}

div.alert table td
{
background: #FFFFFF;
border-top-color: #D8D8D8;
border-top-style: solid;
border-top-width: 1;
padding-left: 5;
padding-right: 5;
border: solid 1 #DEDFEF;
}

span.copyCode
{
color: #0000ff;
font-size: 90%;
font-weight: normal;
cursor: hand;
float: right;
display: inline;
text-align: right;
}

.downloadCode
{
color: #0000ff;
font-size: 90%;
font-weight: normal;
cursor: hand;
}

.viewCode
{
color: #0000ff;
font-size: 90%;
font-weight: normal;
cursor: hand;
}

div.code pre
{
font-family:    Monospace, Courier New, Courier;
font-size: 105%;
color:  #000000;
}

code
{
font-family:    Monospace, Courier New, Courier;
font-size: 105%;
color:  #000000;
}

dl
{
margin-top: 0;
padding-left:   1;
}

dd
{
margin-bottom:  0;
margin-left:    0;
padding-left:   20;
}

dd p
{
margin-top: 5;
}

ul
{
margin-left: 17;
list-style-type: disc;
}

ul ul
{
margin-bottom: 4;
margin-left: 17;
margin-top: 3;
list-style-type: disc;
}

ol
{
margin-left: 24;
list-style-type: decimal;
}

ol ol
{
margin-left: 24;
margin-top: 3;
list-style-type: lower-alpha;
}

li
{
margin-top: 0;
margin-bottom: 0;
padding-bottom: 0;
padding-top: 0;
margin-left: 5;
}

p
{
margin-bottom: 15;
}

.tip
{
color:  #0000FF;
font-style: italic;
cursor:hand;
text-decoration:underline;
}

.math
{
font-family: Times New Roman;
font-size: 125%
}
.sourceCodeList
{
font-family: Verdana;
font-size: 90%;
}

pre.viewCode
{
width: 100%;
overflow: auto;
}

li:hover table, li.over table
{
background-color: #C0C0C0;
}

li:hover ul, li.over ul
{
background-color: #d2d2d2;
border: 1px solid #000;
display: block;
}
            </style>
  </head>
  <body>
    <!--Topic built:08/05/2008 01:28:33-->

    
    
    
    
    
    
    
    
    
    <div id="header">
      <table width="100%" id="topTable"><tr>
          <td align="left">
            <span id="nsrTitle">AdventureWorksOffline Report Samples</span>
          </td>
          <td align="right">
            <span id="headfb" class="feedbackhead">
            </span>
          </td>
        </tr></table>
      
      
      
    </div>
    <div id="mainSection">
      <div id="mainBody"><p> 08/05/2008 01:28:33</p>
        
        <font color="DarkGray"> </font><p /> 
        <span id="changeHistory">
        </span>
    <p>The AdventureWorksOffline report samples are a set of predefined report definition files that use XML representations of data taken from the <b>AdventureWorks</b> databases. As a result, the AdventureWorksOffline report samples do not require an active connection to the AdventureWorks. You can use these sample reports to familiarize yourself with individual features of Reporting Services when authoring reports.</p>
  <h1 class="heading">Scenario</h1><div id="sectionSection0" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">
        Adventure Works Cycles publishes product and sales information that is accessed by employees throughout the company. The reports present this data in a variety of formats.</p>
    </content></div><h1 class="heading">Language</h1><div id="sectionSection1" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">Report Definition Language (RDL)</p>
    </content></div><h1 class="heading">Chart Sample Reports</h1><div id="sectionSection2" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">The AdventureWorks sample reports demonstrate a wide range of report features. The following table provides descriptions that explain the chart samples that are available. </p>
      <table width="100%" cellspacing="0" cellpadding="0" border="1" style="background-color: #CCCCCC;" xmlns=""><tr>
            <th>
              Report
            </th>
            <th>
              Description
            </th>
          </tr><tr>
          <td>
            <p>_AreaCharts</p>
          </td>
          <td>
            <p>This report illustrates properties related to the area chart.</p>
          </td>
        </tr><tr>
          <td>
            <p>_BarCharts_VisualEffects</p>
          </td>
          <td>
            <p>This report illustrates the visual effects that can be set on a bar or column chart.</p>
          </td>
        </tr><tr>
          <td>
            <p>_FunnelCharts</p>
          </td>
          <td>
            <p>This report illustrates how to set properties on the funnel chart.</p>
          </td>
        </tr><tr>
          <td>
            <p>_LineCharts</p>
          </td>
          <td>
            <p>This report illustrates how to set properties on a line chart.</p>
          </td>
        </tr><tr>
          <td>
            <p>_PieCharts_CollectingSlices</p>
          </td>
          <td>
            <p>This report illustrates how to collect small slices on a pie chart.</p>
          </td>
        </tr><tr>
          <td>
            <p>_PieCharts_DisplayingLabelsOutside</p>
          </td>
          <td>
            <p>This report illustrates how to display labels around the outside of a pie chart.</p>
          </td>
        </tr><tr>
          <td>
            <p>_PieCharts_VisualEffects</p>
          </td>
          <td>
            <p>This report illustrates various visual effects that can be set on a pie or doughnut chart.</p>
          </td>
        </tr><tr>
          <td>
            <p>_RadarCharts</p>
          </td>
          <td>
            <p>This report illustrates how to set properties on a radar chart.</p>
          </td>
        </tr><tr>
          <td>
            <p>_Stock Charts</p>
          </td>
          <td>
            <p>This report illustrates how to set properties on a stock chart.</p>
          </td>
        </tr><tr>
          <td>
            <p>Appearance_BorderSkins</p>
          </td>
          <td>
            <p>This report illustrates various border skins that can be applied to the chart.</p>
          </td>
        </tr><tr>
          <td>
            <p>Appearance_ColorPalette</p>
          </td>
          <td>
            <p>This report illustrates various color palettes that can be applied to the chart.</p>
          </td>
        </tr><tr>
          <td>
            <p>Axis_ScaleBreaks</p>
          </td>
          <td>
            <p>This report illustrates how the chart calculates a scale break if there is sufficient space.</p>
          </td>
        </tr><tr>
          <td>
            <p>Axis_SecondaryAxis</p>
          </td>
          <td>
            <p>This report illustrates how to make use of the secondary axis.</p>
          </td>
        </tr><tr>
          <td>
            <p>Axis_SpecifyNumOfIntervals</p>
          </td>
          <td>
            <p>This report illustrates how to show all labels on an axis.</p>
          </td>
        </tr><tr>
          <td>
            <p>Data_AddingCalculatedSeries</p>
          </td>
          <td>
            <p>This report illustrates how to add a calculated series to a chart.</p>
          </td>
        </tr><tr>
          <td>
            <p>Data_HighlightMaxPoint</p>
          </td>
          <td>
            <p>This report illustrates how to highlight the maximum data point in a series.</p>
          </td>
        </tr><tr>
          <td>
            <p>Data_HandlingEmptyPoints</p>
          </td>
          <td>
            <p>This report illustrates how to handle null values by adding empty points to the chart.</p>
          </td>
        </tr><tr>
          <td>
            <p>Data_Trendlines</p>
          </td>
          <td>
            <p>This report illustrates how to add a trend line to the chart.</p>
          </td>
        </tr></table>
    </content></div><h1 class="heading">Gauge Sample Reports</h1><div id="sectionSection3" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">The AdventureWorks sample reports demonstrate a wide range of report features. The following table provides descriptions that explain the gauge samples that are available. </p>
      <table width="100%" cellspacing="0" cellpadding="0" border="1" style="background-color: #CCCCCC;" xmlns=""><tr>
            <th>
              Report
            </th>
            <th>
              Description
            </th>
          </tr><tr>
          <td>
            <p>Gallery_MetallicFrameGauge</p>
          </td>
          <td>
            <p>This report contains an example of a metallic frame gauge. </p>
          </td>
        </tr><tr>
          <td>
            <p>Gallery_Thermometer</p>
          </td>
          <td>
            <p>This report contains an example of a thermometer. </p>
          </td>
        </tr><tr>
          <td>
            <p>Gallery_TurboRPMGauge</p>
          </td>
          <td>
            <p>This report contains an example of a turbo RPM gauge. </p>
          </td>
        </tr><tr>
          <td>
            <p>Pointers</p>
          </td>
          <td>
            <p>This report illustrates how to format the gauge pointer.</p>
          </td>
        </tr><tr>
          <td>
            <p>Scales</p>
          </td>
          <td>
            <p>This report illustrates how to format the gauge scale.</p>
          </td>
        </tr></table>
    </content></div><h1 class="heading">Text Sample Reports</h1><div id="sectionSection4" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">The AdventureWorks sample reports demonstrate a wide range of report features. The following table provides descriptions that explain the text samples that are available. </p>
      <table width="100%" cellspacing="0" cellpadding="0" border="1" style="background-color: #CCCCCC;" xmlns=""><tr>
            <th>
              Report
            </th>
            <th>
              Description
            </th>
          </tr><tr>
          <td>
            <p>HTML_Import</p>
          </td>
          <td>
            <p>This report illustrates how to import HTML into a text box..</p>
          </td>
        </tr><tr>
          <td>
            <p>HTML_MailMerge</p>
          </td>
          <td>
            <p>This report illustrates how to create a mail merge after importing HTML into a text box.</p>
          </td>
        </tr><tr>
          <td>
            <p>Text_FormattingSelected</p>
          </td>
          <td>
            <p>This report illustrates how to mix multiple formats inside of a single text box.</p>
          </td>
        </tr><tr>
          <td>
            <p>Text_MailMerge</p>
          </td>
          <td>
            <p>This report illustrates how to create a mail merge inside of a single text box.</p>
          </td>
        </tr></table>
    </content></div><h1 class="heading">Prerequisites</h1><div id="sectionSection5" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">Your system must have Business Intelligence Development Studio installed.</p>
      <div class="alert" xmlns=""><table width="100%" cellspacing="0" cellpadding="0"><tr><th align="left">Note: </th></tr><tr><td>
        Business Intelligence (BI) Development Studio is not supported on Itanium-based computers. However, support for BI Development Studio is available for x64-based computers. If the SQL Server sample databases have been deployed on an Itanium-based computer, use BI Development Studio on either an x86-based or x64-based computer to modify and run the samples.<p />
      </td></tr></table><p /></div>
    </content></div><h1 class="heading">See Also</h1><div id="seeAlsoSection" class="section" name="collapseableSection"><h4 class="subHeading">Tasks</h4><a href="html/e8117979-fe03-441e-be85-894fa616227a.htm">Considerations for Installing SQL Server Samples and Sample Databases</a><br /><a href="html/a3c209ec-283f-4d74-a3a2-899e89ebbec0.htm">AdventureWorks Report Samples</a><br /><h4 class="subHeading">Other Resources</h4><b>Working with Chart Data Regions</b><br /><b>Working with Gauge Data Regions</b><br /><br />
		<h4 class="subHeading">
			Help and Information
		</h4>
		<b>
			
			Getting SQL Server 2008 Assistance
		</b>
	</div><!--[if gte IE 5]>
			<tool:tip element="seeAlsoToolTip" avoidmouse="false"/><tool:tip element="languageFilterToolTip" avoidmouse="false"/><tool:tip element="roleInfoSpan" avoidmouse="false"/>
		<![endif]--></div>
      <div id="footer">
			
			© 2008 Microsoft Corporation. All rights reserved.
		</div>
    </div>
  </body>
</html>